﻿

create proc dbo.GetVorwahlen
@VorwahlKey	int = null
as
begin
	set nocount on

	select	v.VorwahlKey,
			v.Vorwahl
	from	dbo.Vorwahl v
	where	v.VorwahlKey = @VorwahlKey
				or @VorwahlKey is null

end
GO
GRANT EXECUTE
    ON OBJECT::[dbo].[GetVorwahlen] TO PUBLIC
    AS [dbo];

